home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
The 640 MEG Shareware Studio 2
/
The 640 Meg Shareware Studio CD-ROM Volume II (Data Express)(1993).ISO
/
business
/
l303np.zip
/
NP_READ.ME
< prev
Wrap
Text File
|
1990-05-02
|
4KB
|
97 lines
Date: 5-02-90
Time: 9:00 am
from the desk of Lonnie J. Rolland:
Please find enclosed a "SHAREWARE" version, full featured, call
logger. It uses DBase III compatable .dbfs and .dbt
*** It runs on a network with full record/file locking, therefore
*** you MUST run dos's SHARE program first!
Envoke it as 'L3np' on a monochrome system. Or envoke it as
'L3np /C' on a color system to get some red, white, and blue.
It's a 70kb program that is stand alone and complete. The file
'L3DBB.ZIP' is a set of empty .dbf/.dbt files. The file
'L3_PDBT.EXE' is a packer for the memo field file.
Delete and pack the .dbf's offline with dbase. Note, it you delete
record #125 in L3main, you must also delete record #125 in L3memo.
Then run the L3_PDBT program offline to clean out orphaned memos.
Note that an orphaned memo will happen when you: 1) delete and pack
out the .dbf that points to the memo, 2) edit an existing memo and
make it grow larger in size than originally (512/1024/1536...etc).
The structures for L3MAIN.DBF is:
Field Field Name Type Width Dec
1 VENDOR Character 18
2 PRODUCT Character 12
3 CALLER Character 61
4 CUSTOMER Character 59
5 ADDRESS Character 67
6 CITY Character 15
7 STATE Character 5
8 ZIP Character 5
9 PHONE Character 20
10 HARDWARE Character 65
11 SOFTWARE Character 66
12 SERIALNO Character 18
13 PROBLEM Character 21
14 CLOSED Character 1
** Total ** 434
The structures for L3MEMO.DBF is:
Field Field Name Type Width Dec
1 ORIGIN Character 7
2 STARTDATE Character 8
3 STARTTIME Character 5
4 STOPDATE Character 8
5 STOPTIME Character 5
6 ELAPSETIME Character 5
7 MEMOFLD Memo 10
** Total ** 49
Logger has got timer, find, browse and does date/time stamping.
The timer (T) command starts an entry. The find (F) command is neat.
It works on the caller name or problem. It'll find embedded strings
and is case insensitive. The browse (B) command uses up, down, PgUp,
PgDn, home, and end keys. Browse will remember where you were browsing
at last. You may start the timer then escape out of the entry to do
| a browse or find and return back to the entry. When you end your edit
| from a find or browse start, logger will ask you if you want to:
| (maintainance mode) re-write the record back to where it came from,
| or (add mode) append the record as a new one to end of the dbf. The
memo pad portion saves 512 bytes min, 4096 max and does word-wrap too!
Logger was written by me with toolboxes from Max Software Consultants
and Turbo Power. (they were an odd couple marriage)
It does and will take advantage of 4 environment variables called:
1) NETNAME 2) LOGVENDOR 3) LOGPRODUCT and 4) LOGDRIVE. Netname gets
plugged into originator (BY:). Logvendor gets plugged into vendor.
Logproduct gets plugged into product. And logdrive sets up the disk
drive and subdirectory where your data will sit. Note you do not need
to use any of these variables. They are there to make your life easier.
I run Artisoft's Lantastic AI Netbios/NOS.
I have my data sitting on the server in 'K:\LOGGER3\xxxx.dbf'.
I have my neton batch file setting up the variables as:
'set logdrive=K:\LOGGER3\'
'set netname=LONNIE'
'set logvendor=COMPANY_XYZ'
'set logproduct=WIDGET'
You (for instance) can load your data in 'C:\BILLABLE\xxxx.dbf'.
Note you may need to expand your environment size beyond the default
160 bytes by placing the following in your config.sys file.
'shell c:\command.com c:\ /e:256 /p'
I will not be held responsible for your data loss or your hardware.
I am a Senior Tech Support Engineer. I gen'ed this program to
maintain our customer database (here) at work.
I want your feedback! Call my company BBS and drop me a note.
It's number is (714) 545-7671.
<relax & enjoy>
(c) Copyright 1990, Lonnie J. Rolland, Symbol/MSI, Costa Mesa, CA